<?php
	$conn = mysql_connect("localhost","root","1234") or die(mysql_error());
	$db = mysql_select_db("cartoontoday") or die("Cannot select db");
	mysql_query("SET character_set_results=tis620");
    mysql_query("SET character_set_client=tis620");
    mysql_query("SET character_set_connection=tis620");
	mysql_query("SET NAMES windows");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>แก้ไขข้อมูลสำนักพิมพ์</title>
<style type="text/css">
body {
	background-color: #82AFFB;
}
</style>
</head>

<body>
<table width="855" height="522" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td height="133" colspan="8"><img src="../image/mix.jpg" width="890" height="195" /></td>
  </tr>
  <tr>
    <td width="150" height="52"><a href="file:///G|/pppppppppppppppppppppppppp/bok/add_officer.php"><img src="../image/menuadmin1.jpg" width="140" height="40" /></a></td>
    <td width="144"><a href="file:///G|/pppppppppppppppppppppppppp/bok/add_members.php"><img src="../image/menuadmin2.jpg" width="140" height="40" /></a></td>
    <td width="159"><a href="file:///G|/pppppppppppppppppppppppppp/bok/Addbook.html"><img src="../image/menuadmin3.jpg" width="140" height="40" /></a></td>
    <td width="153"><a href="file:///G|/pppppppppppppppppppppppppp/bok/add_pub.php"><img src="../image/menuadmin4.jpg" width="140" height="40" /></a></td>
    <td width="149"><img src="../image/menuadmin5.jpg" width="140" height="40" /></td>
    <td width="149"><img src="../image/menuadmin8.jpg" width="140" height="40" /></td>
  </tr>
    <td colspan="8" align="center"><form id="form1" name="form1" method="post" action="file:///G|/pppppppppppppppppppppppppp/bok/save_editpub.php?PubID=<?php echo $_GET["PubID"];?>">
      <table width="604" border="0">
        <tr>
          <td colspan="2">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;แก้ไขข้อมูลสำนักพิมพ์</td>
          </tr>
        <tr>
          <td>รหัสสำนักพิมพ์</td>
          <td><input name="PubID" type="text" id="PubID" size="30" maxlength="5" value="<?php echo $objResult["PubID"];?>" />
            *</td>
          </tr>
        <tr>
          <td width="139">ชื่อสำนักพิมพ์</td>
          <td width="400"><label for="PubName"></label>
            <input name="PubName" type="text" id="PubName" maxlength="50" value="<?php echo $objResult["PubName"];?>" /></td>
          </tr>
        
        <tr>
          <td height="28">&nbsp;</td>
          <td><input type="submit" name="Submit" id="Submit" value="ตกลง" />
            <input type="reset" name="Reset" id="Reset" value="ยกเลิก" />
            &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
          </tr>
        </table>
    </form>
    </form></td>
    <?php
	$objConnect = mysql_connect("localhost","root","1234") or die("Error Connect to Database");
	$objDB = mysql_select_db("cartoontoday");
	$strSQL=mysql_query("SET NAMES TIS620");
	$strSQL = "SELECT * FROM publisher WHERE PubID = '".$_GET["PubID"]."' ";
	$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
	$objResult = mysql_fetch_array($objQuery);
?>
    </tr>
</table>
</body>
</html>